

/****** Object:  StoredProcedure [dbo].[SP_recMenuRights_SelectByID]    Script Date: 05/10/2014 08:24:49 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		Beni Khaeroni (jhung.ben@gmail.com)
-- Create date: 09 Mei 2014 10:20 AM
-- Description:	
-- =============================================
CREATE PROCEDURE [dbo].[SP_recMenuRights_SelectByID]
(
	@MenuRightsID						[int]
)
AS

Select 		MenuRightsID	AS	'MenuRightsID',
		MenuID	AS	'MenuID',
		RoleID	AS	'RoleID',
		(Select Title From Acces Where Code = AccessCode)	AS	'AccessCode',
		CreatedDate	AS	'CreatedDate',
		CreatedBy	AS	'CreatedBy'

From	master.recMenuRights
WHERE
(
	 [MenuRightsID]	 = @MenuRightsID
)
GO


